I need to send a SQL query to a database that tells me how many rows there are in a table. I could get all the rows in the table with a SELECT ... ... <看更多>

SQL for counting rows of all tables (tested on Oracle 10g). -- http://laurentschneider.com/wordpress/2007/04/how-do-i-store-the-counts-of-all-tables.html. ... <看更多>

To answer your immediate question, how to count rows of a subquery, the syntax is as follows: SELECT COUNT(*) FROM (subquery) AS some_name;. ... <看更多>

... <看更多>